/*
 Navicat Premium Data Transfer

 Source Server         : 京东云_mysql
 Source Server Type    : MySQL
 Source Server Version : 80032
 Source Host           : 117.72.182.157:3306
 Source Schema         : ai_mcp_knowledge

 Target Server Type    : MySQL
 Target Server Version : 80032
 File Encoding         : 65001

 Date: 20/08/2025 11:57:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mcp_config
-- ----------------------------
DROP TABLE IF EXISTS `mcp_config`;
CREATE TABLE `mcp_config` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `mcp_app_name` varchar(50) NOT NULL COMMENT 'mcp应用的名字',
  `mcp_app_key` varchar(50) NOT NULL COMMENT 'json字段的名字',
  `mcp_config_json` json NOT NULL COMMENT 'JSON格式的MCP配置',
  `mcp_config_value` json NOT NULL COMMENT 'JSON 格式的其他配置项',
  `mcp_transport_type` varchar(12) NOT NULL DEFAULT '' COMMENT 'mcp通信类型',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mcp_app_name` (`mcp_app_name`),
  UNIQUE KEY `mcp_app_key` (`mcp_app_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of mcp_config
-- ----------------------------
BEGIN;
INSERT INTO `mcp_config` (`id`, `mcp_app_name`, `mcp_app_key`, `mcp_config_json`, `mcp_config_value`, `mcp_transport_type`, `create_time`, `update_time`) VALUES (1, 'CSDN发帖 + 微信通知', 'mcp_csdn_weixin', '{"mcpServers":{"mcp-server-csdn":{"args":["-Dspring.ai.mcp.server.stdio=true","-jar","/ai-mcp-knowledge/doc/dev-ops/mcp/ai-mcp-server-csdn-1.0.0.jar","--csdn.api.categories=Java场景面试宝典","--csdn.api.cookie=uuid_tt_dd=10_9922692570-1742872102005-141284; fid=20_40878333764-1744080772992-999736; p_uid=U010000; csdn_newcert_weixin_43394342=1; __gads=ID=1b9d09f1d892a40a:T=1744080774:RT=1751959196:S=ALNI_Mb7N1M7frL0_WZUuToAiTs3m68uUA; __gpi=UID=00001009b8b5147e:T=1744080774:RT=1751959196:S=ALNI_MZv7USsxl5HfFdhX4Wng-zBxc-tIw; __eoi=ID=45c6c2036861ef04:T=1744080774:RT=1751959196:S=AA-AfjbbTYCgX-bOH_kPjpH55llA; FCNEC=%5B%5B%22AKsRol83AT9ciGz2SLYMNyfub7110Du2megCtkqEOt_Lzsreiv0O0EtfpVlMXgxi-eWJh6qpvbeP8BLZdvkxRT9s9ItW52U6Zb_c_fKc8xUSWSLUaVIFriUHwxcZFxH3SjMj37qSbj4hQW7lH_QGOABjEtxJ3rHGYQ%3D%3D%22%5D%5D; c_segment=4; c_ab_test=1; dc_sid=6623cf05c17e4aba41f29d6d919c88df; Hm_lvt_6bcd52f51e9b3dce32bec4a3997715ac=1753065412,1755243047; HMACCOUNT=DF0BDEEA02104FE9; SESSION=02406ca8-9555-4c91-9312-6b53b42e924d; loginbox_strategy=%7B%22taskId%22%3A317%2C%22abCheckTime%22%3A1755243890291%2C%22version%22%3A%22ExpA%22%2C%22nickName%22%3A%22%E7%89%9B%E4%B8%8A%E7%9A%84%E7%8C%BF%22%7D; UserName=m0_48870826; UserInfo=ebf239df56184e2bb890fe4b0ea0c3e7; UserToken=ebf239df56184e2bb890fe4b0ea0c3e7; UserNick=Code8848; AU=D80; UN=m0_48870826; BT=1755244195804; csdn_newcert_m0_48870826=1; c_first_ref=www.baidu.com; is_advert=1; _clck=jzjuxe%7C2%7Cfyk%7C0%7C1924; creative_btn_mp=3; dc_session_id=10_1755506470273.843893; c_first_page=https%3A//www.csdn.net/; c_dsid=11_1755506470749.105490; c-sidebar-collapse=0; creativeSetApiNew=%7B%22toolbarImg%22%3A%22https%3A//img-home.csdnimg.cn/images/20230921102607.png%22%2C%22publishSuccessImg%22%3A%22https%3A//img-home.csdnimg.cn/images/20240229024608.png%22%2C%22articleNum%22%3A10%2C%22type%22%3A2%2C%22oldUser%22%3Atrue%2C%22useSeven%22%3Afalse%2C%22oldFullVersion%22%3Atrue%2C%22userName%22%3A%22m0_48870826%22%7D; _clsk=1wq31hz%7C1755506480660%7C3%7C0%7Cq.clarity.ms%2Fcollect; c_pref=https%3A//blog.csdn.net/m0_48870826%3Ftype%3Dblog; c_ref=https%3A//editor.csdn.net/; c_page_id=default; Hm_lpvt_6bcd52f51e9b3dce32bec4a3997715ac=1755506569; log_Id_pv=5; log_Id_view=176; dc_tos=t16ljo; log_Id_click=5"],"command":"java"},"mcp-server-weixin":{"args":["-Dspring.ai.mcp.server.stdio=true","-jar","/ai-mcp-knowledge/doc/dev-ops/mcp/ai-mcp-server-weixin-1.0.0.jar","--weixin.api.original_id=gh_09df3d55d6dc","--weixin.api.app-id=wx032c09c7cdb57cc2","--weixin.api.app-secret=46ccb1e6b3ef98352236ad82393fec83","--weixin.api.template_id=q-1o9IHmPmVLpXdvgxTFy3_-X7YX-k6DRLC7JPHPVR0","--weixin.api.touser=oL8jC7REHh2xOMystc8JhO_fSEuA"],"command":"java"}}}', '{\"initialize\": true, \"requestTimeout\": \"360s\"}', 'stdio', '2025-08-19 19:10:22', '2025-08-19 19:10:22');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
